﻿CREATE TABLE [dbo].[Ticket]
(
	TicketNumber int NOT NULL CONSTRAINT PK_Ticket PRIMARY KEY IDENTITY(1,1), 
	Intinerary int NOT NULL CONSTRAINT FK_Ticket_Intinerary REFERENCES Intinerary(Id),
	Seat int NOT NULL CONSTRAINT FK_Ticket_SeatRegion REFERENCES SeatRegion(Id),
	FlightOrder int NOT NULL
)